﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetDetalleAsignacionByIdAsignacion')
	BEGIN
		DROP  Procedure  GetDetalleAsignacionByIdAsignacion
	END

GO

CREATE Procedure GetDetalleAsignacionByIdAsignacion

	(
		@idAsignacion int
	)

AS

BEGIN
	SET NOCOUNT ON
	
	SELECT
	[Cantidad],
	[Comentario],
	[IdAsignacion],
	[IdBien],
	[IdEmpleado]
	FROM [DetalleAsignacion] 
	WHERE [IdAsignacion] = @idAsignacion

	SET NOCOUNT OFF
END

GO


GRANT EXEC ON GetDetalleAsignacionByIdAsignacion TO PUBLIC

GO


